Frank B. ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	16

About Me

About Me

Not much happening here, yet.

Analytics

49

Posts

161

Visits

565

Points

Feb 21, 2023

Join Date

Feb 6, 2025

Last Active

Reactions

• Insightful 3

  3
• Vote Up 6

  6
• Awesome 8

  8

• Activity
• Discussions6
• Comments43

• Re: Using COUNTIF, referencing data in a different sheet

  Frank B.

  03/17/23
  The reason you are getting the "#Invalid Ref" error in your formula is that you are using the wrong syntax for the COUNTIF function. The correct syntax for the COUNTIF function in Smartshee…
  1 ·

• Re: Can I connect an auto-generated number to an email and link to separate sheets?

  Frank B.

  03/17/23
  Yes, it is possible to have the Guest ID from the Invite sheet auto-populate on the RSVP sheet when a person responds to the invitation. One way to achieve this is to use the VLOOKUP function in Smar…
  1 ·

Previous